'''
Created on Jul 10, 2010

@author: dgentry
'''

import sqlite3
    
conn = sqlite3.connect('db')

c1 = conn.cursor() # for create

#  create tables

print "Creating TABLE podcasts"

try:
    c1.execute('CREATE TABLE podcasts (title VARCHAR2(254),url VARCHAR2(254))')
except:
    print "TABLE podcasts already exists"
    
print "Creating TABLE choices"
    
try:
    c1.execute('CREATE TABLE choices (title VARCHAR2(254),url VARCHAR2(254),pull_date VARCHAR2(14))')
except:
    print "TABLE choices already exists"

#  close database

conn.close()
    